package com.icart.repositories;


import com.icart.entities.BiChnstaffEntity;
import com.icart.entities.BiUserEntity;
import org.springframework.context.annotation.Scope;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

@Repository
@Scope("prototype")
public interface BiStaffRepository extends BaseRepository<BiChnstaffEntity,Integer> {
    /*通过staffid查出门店chnid*/
    @Query(nativeQuery = true,value = "select * from bi_chnstaff where staffid=?1 and status=1")
    BiChnstaffEntity findchnid(Long staffid);
}

